/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package hvkdbmc.setting;

/**
 *
 * @author LuckyMan
 */
public class HVKSetting {

    public static String databaseType = "oracle"; //  sqlserver // mysql
    public static String databaseConnectionString = "jdbc:oracle:thin:@123.30.191.96:1521:crm";
    public static String databaseUsername = "TICVNPT";
    public static String databasePassword = "ad036VTQN15";
    public static String myConnection;
    
    public static String ibatisMapRootFolder = "C:\\ABC\\Ibatis";
    public static String daoRootFolder = "C:\\ABC\\Dao";
    public static String serviceRootFolder = "C:\\ABC\\Service";
    public static String modelMapRootFolder = "C:\\ABC\\Model";
    public static String formRootFolder = "";
    
    public static String modelMapRootPackage = "vntic.quangninh.model";
    
    public static String daoPackage = "vntic.quangninh.dao";
    public static String servicepackage="vntic.quangninh.service";
    
    public static String prefixNamespaceXMLMap = "NS";
    public static String suffixXMLMapAlias = "Object";
    public static String prefixClass = "HVK";
    public static String suffixModel = "Model";
    public static String suffixDao = "Dao";
    public static String suffixIbatisDao = "IbatisDao";
    public static String suffixResultMap = "Result";
    public static String suffixService = "Service";
    public static String suffixDaoService = "DaoService";
    
    
    public static String oracleGetAllTableNames = "SELECT  TABLE_NAME FROM USER_TABLES";
    public static String oracleGetAllColumnInfo = "SELECT COLUMN_ID,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,NULLABLE,DATA_DEFAULT FROM USER_TAB_COLUMNS WHERE TABLE_NAME = ";
    public static String oracleGetPrimaryKeyForColumnInfo = "SELECT COLUMN_NAME FROM USER_CONS_COLUMNS A JOIN USER_CONSTRAINTS C  ON A.CONSTRAINT_NAME = C.CONSTRAINT_NAME WHERE C.CONSTRAINT_TYPE = 'P' AND C.TABLE_NAME = ";
    
    public static String fileLoggerError = "C:\\ABC\\logError.log";
    public static String fileLoggerAction = "C:\\ABC\\logAction.log";
    
    public static String oracle_java_type_mapped_file = "src/hvkdbmc/setting/oracle_java_lower.properties";
    public static String oracle_java_jdbc_type_mapped_file="src/hvkdbmc/setting/oracle_jdbc_full.properties";
    
    public static String spring_map_doctype = "<!DOCTYPE sqlMap PUBLIC \"-//iBATIS.com//DTD SQL Map 2.0//EN\" \"http://www.ibatis.com/dtd/sql-map-2.dtd\">";
    
    
}
